SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 387191 LIMIT 1 [ RunTime:0.002112s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 387191 [ RunTime:0.002724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496171,956088,292861,98836,634870,632915,224651,1023919,992874,1036304,59460,566128,880377,155135,403668,853695,294996,823363,903076,557230,317023,76461,548817,103168,488134,974489,306455,102325,854535,1046009,759594,552875,470685,520956,14486,943442,223879,963510,329455,488857,1038052,794241,1035113,762913,416339,82424,258242,101304,607966,593618,114746,332249,936008,661346,521028,107204,433850,642647,994041,730280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 387191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 387191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]