SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 792610 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 792610 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762543,67658,966441,571476,387785,1023096,449151,244588,510996,177672,590991,769489,17574,688294,198192,844403,717694,286341,451059,131090,126966,361617,436988,912001,84949,348549,155866,106841,827974,875120,167295,159199,1044924,927910,103033,754059,237682,502482,599377,127795,322237,424502,913988,86421,331667,676666,721191,884371,328915,276773,874543,924079,869657,786802,876558,579715,1003515,163511,429454,444860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 792610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 792610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]