SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501457 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501457 [ RunTime:0.002835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (660843,898971,658229,292833,134441,168865,672997,193869,1031259,62230,428707,745424,914523,158414,47519,407275,430638,958005,972223,643101,115651,310427,806524,37386,49203,928794,471493,769064,483573,597822,428671,189614,587215,451544,259996,620739,824216,364232,970608,214594,50630,1023806,128470,640107,972682,572705,360488,470241,407356,836988,635721,640829,979688,533768,274549,898631,798721,333203,831525,503391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]