SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001622 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001622 [ RunTime:0.002154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370801,926590,369980,1045221,657183,350256,22257,16722,676552,156765,50715,481078,651291,10145,291350,583187,545540,222661,172323,422833,578839,293573,862225,993325,506084,746035,701362,397332,834389,405156,1042896,263603,544801,703120,132414,252952,1018886,462839,752014,260353,521132,535423,348815,360432,785098,998456,155544,915201,875542,759579,452862,760634,760363,848504,675149,35886,48502,920414,868156,879552) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001622 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001622 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]