SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100183 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100183 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202484,1011321,542019,216244,891940,1041622,416946,934764,976033,436220,632484,349457,416060,479763,430705,731105,664468,287472,291450,540187,1031905,430028,842605,777052,606858,26992,1033245,528529,138934,84447,567776,444141,900669,794706,522851,599524,169006,553204,897170,57059,533154,209114,567621,422402,335060,677090,910293,980441,833398,496458,106288,477785,470737,853745,711058,148606,237483,826454,975767,644543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]