SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534383 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534383 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491797,953885,123428,343495,943232,778314,350712,140860,627119,567161,72978,704462,296364,818957,1000181,484890,57232,767087,790924,916517,360217,990941,305526,389306,50118,792273,848665,271356,951373,218922,818519,4150,29633,421151,918998,955714,886043,999989,299233,13138,4611,32336,58900,663572,663557,209035,345695,358981,68692,938776,508462,82103,582602,336501,223260,270301,743691,235294,721111,538341) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]