SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809843 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809843 [ RunTime:0.003827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030083,985707,968517,55063,257786,904235,743363,754587,749105,723921,1000716,37469,224145,35796,263530,478574,890959,16050,674760,546562,748614,580568,139318,776799,999390,354994,265464,995568,352136,578355,477770,880854,79253,134402,288001,44432,481240,852838,76470,177853,844215,107831,507261,940982,53217,1008688,747647,761847,305157,782365,458025,377855,915850,389503,39728,417028,47559,99781,677486,538314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]