SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030588 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030588 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261917,862291,762624,874095,236460,895673,1036273,977095,398751,237784,806088,1026432,329918,771080,775975,871350,252985,677004,22306,743747,7186,515768,484932,129666,901254,993513,330478,556895,702335,789966,875702,1030793,358497,709697,508518,986818,145019,401558,103110,210642,165276,514241,296064,70685,490993,345966,188044,380944,659647,349643,407601,948315,148117,694449,735212,467247,935500,336505,628209,31258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]