SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040411 LIMIT 1 [ RunTime:0.001017s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040411 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925446,389363,422805,562972,181499,418193,793025,665017,527634,476088,249378,168706,869410,941215,729189,52843,310788,947887,344788,157915,625553,965548,991072,913517,858500,96892,238225,465685,621749,163162,152629,779516,260333,206711,354202,144921,907564,398084,447042,637574,470333,418387,407499,358085,376655,748257,485859,426130,152561,9783,536573,1008332,52700,174552,333919,931483,750206,70072,93075,422454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001472s ]