SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485151 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485151 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013940,384812,773924,532875,425466,754606,874161,184252,776622,310566,110898,497443,229071,203043,993508,30418,35093,128986,332506,50097,451104,946439,100285,130153,889441,702766,764309,215707,626998,313343,921736,490281,987375,644775,483481,669361,161720,393805,55719,146276,200922,869033,916166,170308,262606,797490,10581,132416,271113,966863,619825,386674,310168,933943,406607,988702,774315,952271,624526,432961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]