SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520076 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520076 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196533,100514,913019,944456,1027231,297935,707592,6678,648310,94546,998097,1019473,178455,1010857,630948,369690,424897,838829,280578,667876,922816,498343,430795,251360,242785,460500,609491,467472,634184,312272,99317,326300,505228,776587,502629,588674,488075,829385,645695,19074,37062,289745,647542,347172,806315,1041130,348784,719114,412080,140416,503910,889245,926650,675239,760609,277725,122605,337082,655191,383038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]