SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287184 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287184 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650094,39199,482193,352343,920146,869733,142609,463043,675464,179423,346093,344951,519305,644651,168457,791407,377346,629095,548731,692033,519650,177177,466368,684909,300823,87137,171745,980517,189424,234547,62000,13495,451341,645573,39000,862714,735984,243554,1000146,480055,701640,1045375,398187,80527,802110,537018,540462,204978,950824,726159,1046001,858740,267007,383164,300436,49644,600005,202772,253347,612457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]