SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544620 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544620 [ RunTime:0.001412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9399,504124,488630,59605,810095,838546,803840,807204,764037,916551,185688,491587,808182,201283,421395,252294,1044155,867730,64213,118985,549363,541828,730746,870116,833805,472513,610010,118757,893005,637516,419726,550701,1011160,693495,399384,798037,509489,672382,295595,593661,612875,873002,478633,1033860,536331,1030734,204398,751609,908415,781792,1020115,917032,319985,158333,124092,180629,648363,851103,1023261,114914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]