SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400193 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400193 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111834,442792,255078,706252,201273,457986,453242,196688,90844,339585,531252,213014,743845,34448,327528,499301,81398,1036484,517886,401399,827818,852578,97983,900696,506272,384253,651850,216208,694157,384416,774834,472484,1029237,16470,308585,987335,372494,651436,635497,991214,32300,393366,695425,443749,153306,262796,1015677,924919,91880,217774,228377,1010691,102242,70189,296434,271444,127734,993806,58130,276036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]