SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012187 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012187 [ RunTime:0.002830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331169,706764,86463,55323,85881,32206,34119,119183,893818,107690,1020136,418401,733580,83833,773173,56260,553750,426335,447988,164302,286757,100294,125913,927934,819555,226066,745311,677818,1036152,378278,291561,323093,379380,311496,787089,67944,220185,609996,673976,10380,581914,319790,404184,7723,1036153,570218,833609,243820,915783,491211,165566,646027,537795,301229,328563,392189,169985,968059,597177,225057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002831s ]