SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001987s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31100 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31100 [ RunTime:0.002439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286399,902328,982844,435021,463410,831933,418315,770290,46118,185143,209454,433835,160966,377491,104254,517971,885697,991501,58416,648573,661753,851078,330392,875407,876359,96124,691409,674615,843619,333758,46501,813333,186512,309940,124794,336033,943325,527710,269588,849307,761085,815901,615188,662639,832658,2692,455256,674358,299842,410037,403195,821681,1016760,907064,210926,119009,627825,777129,543134,442705) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]