SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438575 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438575 [ RunTime:0.003024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896365,313168,644824,104121,259708,358337,24741,624061,446171,946487,589916,1020095,108303,980527,767542,164368,709899,691750,166083,279770,817708,328678,844139,501781,1035843,468947,289280,952465,804513,689081,890067,968457,372752,892906,650798,748120,269172,647727,439547,625441,292498,316541,664898,669111,111496,98968,209111,7710,177418,358876,939076,972828,687653,791597,303908,598724,508314,648417,767270,754188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]