SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513542 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513542 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31770,956352,1023390,76266,848982,569117,1037956,269727,358165,782595,944480,967913,635733,76368,152731,788895,767017,606664,379035,980881,1008251,688430,798876,501632,78838,903210,158777,496117,469368,855659,716245,709314,166414,432473,1033275,638531,723960,121534,815213,57711,614849,878028,817579,311075,492130,624344,941175,8021,126157,396494,248053,829845,228220,657768,787288,39105,528839,67640,637294,318381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]