SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 152241 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 152241 [ RunTime:0.002299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604694,323892,63948,50777,513457,883079,648495,494232,633151,443042,176005,529758,729926,430347,886514,299645,950131,244635,97372,711852,175626,300076,219343,210572,442516,621526,25475,263470,412829,764591,135537,943501,672936,12807,424055,194450,840167,312579,74900,78316,511306,542181,12316,7795,406772,207485,1914,948860,717718,341426,844473,980035,252614,597181,275559,978712,548366,811702,390558,668518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 152241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000796s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 152241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]