SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101882 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101882 [ RunTime:0.003246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258071,946268,764142,1042794,572254,995601,894025,482455,739361,1007332,665656,322747,482978,332547,174073,153111,324656,696993,875744,469718,912442,256806,192940,383159,616154,453825,843584,798784,567573,62976,222649,578861,188555,944462,720197,478084,529875,726504,97646,1022461,957119,996963,904993,285636,832477,324635,167136,1018625,120718,395393,712317,909117,925122,228860,594686,160290,778720,323669,411227,948691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101882 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101882 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]