SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 359268 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 359268 [ RunTime:0.001100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222002,311014,142043,229474,335642,58083,585012,160697,620209,522931,762428,584134,996053,57523,320099,44175,361888,131876,1026645,728549,633196,414547,509220,537816,750208,222120,387174,915643,908980,367733,262804,269193,336198,373099,820978,46094,74182,950465,1019343,393316,592363,899902,289908,616070,925914,480436,545897,906181,398605,960984,246884,984179,163412,436611,188819,91333,547681,983364,778215,551933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 359268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 359268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]