SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.009321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261429 LIMIT 1 [ RunTime:0.005362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261429 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024211,950850,404493,157197,535590,380402,221742,1013934,497752,835165,347530,800861,986039,768363,377896,195386,467009,727264,7789,493096,636661,860103,301896,781909,324155,853734,223634,786446,468280,902922,281290,1005092,120131,389364,1085,15471,764381,40918,57056,407054,659491,699950,983769,405194,896421,144796,119694,66821,899325,805552,888708,68996,85080,874624,65246,379922,97309,78563,974560,115063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]