SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146540 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146540 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126946,1020695,959333,434283,53209,193008,668194,40110,151384,472859,998225,362285,726004,977537,781509,256756,74670,741389,478256,1007345,350173,1021602,647453,155266,398746,565019,208301,313392,584146,256351,898394,812898,51840,678381,383462,945065,422165,297781,772875,138402,376156,536329,916392,124673,726435,142068,185068,681881,160901,656178,594726,154538,513712,813619,282756,284453,845718,354007,78641,95811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]