SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200035 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200035 [ RunTime:0.003740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916590,792138,750884,59205,534557,869814,766878,903928,960525,1016747,764655,171429,122484,165858,936464,22744,667657,1013875,62946,193614,618589,144448,255737,461652,466334,403724,410106,878752,184497,1007921,581153,103792,588434,110985,128735,407346,493179,7471,1027378,190553,485434,991473,749969,525824,102944,395089,230412,106457,842342,298764,137635,315046,782327,564613,803901,251890,734806,958838,430420,807292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002654s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]