SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465020 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465020 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927143,325533,869182,934716,498836,33347,1040734,862553,257997,19924,528224,998639,814680,54466,698921,45349,1043885,1017647,1011681,425334,983546,697633,968743,453717,743824,453871,784517,30314,880831,1009560,715535,307057,606294,146968,400868,1034422,193280,468248,372824,362045,997351,764181,790439,203857,72101,691973,959530,791379,888299,189481,430697,409627,409057,779668,896691,572568,60509,555816,941205,918242) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]