SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040276 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040276 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564185,877930,976560,142337,1023142,174663,594610,665932,336144,360790,853652,193924,363960,611680,876454,782374,406442,998771,28445,227199,324705,361714,493266,229411,291751,236085,936711,865580,708241,181296,353134,579655,389123,730170,970290,60236,991723,835502,469075,211437,773285,198771,83440,438286,824128,600826,941384,731556,148443,875026,585314,825033,513789,89378,635155,817520,514796,26224,375792,912792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]