SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265023 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265023 [ RunTime:0.004276s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145390,918102,645199,488948,1017637,724779,405888,777856,384032,23232,73584,11013,695286,343200,16939,936992,1006261,90088,619175,178680,748354,132039,495928,730441,870958,575334,591813,974659,985073,98389,31261,682580,587397,74907,359811,311308,714888,1042967,531909,295213,649501,194997,777509,297230,110330,558068,929938,457727,982702,217783,839574,487568,943484,582528,182491,666568,971188,109365,98489,534433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]