SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10864 LIMIT 1 [ RunTime:0.001160s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10864 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142921,426992,583864,896976,962026,453927,354235,850193,509934,292916,46458,324448,504229,478216,292754,820205,508205,320082,176926,636282,769544,264760,9832,970931,1044339,913873,564186,1026311,1046026,437710,522485,534384,272294,6305,911759,412204,831661,408135,942151,842059,231889,4139,949733,821258,865069,58310,1047606,54227,895688,539401,868362,432686,669613,677436,9025,858767,888792,945648,857323,1028161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]