SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568218 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568218 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854043,874978,444682,458668,124590,143904,347127,1028539,276098,201895,373923,54023,367825,1029303,323610,174308,787323,527706,589314,535536,399341,787780,435367,528389,890911,784369,503626,459881,283894,83781,413766,376293,90676,26263,736275,453805,430372,1035076,385659,441290,942406,231031,593763,908052,792419,2314,152480,537548,519821,527386,137996,509153,258800,869478,584327,826008,249840,913251,490004,239879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001863s ]