SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140151 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140151 [ RunTime:0.002807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42343,996014,171376,773247,144354,289636,375022,1026401,29556,84159,469197,1001679,295337,1047221,339577,655765,391417,507374,815229,876204,964112,563802,871795,400433,998457,585948,734545,964818,354045,327566,917699,717924,136701,592458,722565,640713,1009238,568058,796034,578994,176573,37202,363265,497376,908603,34333,900146,276545,538919,350255,91404,1002753,789882,44610,790615,482947,391246,200619,240360,460724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]