SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480610 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480610 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796718,570508,32212,995499,546494,696967,184697,1022298,807663,793729,65525,194663,323712,1007096,936788,10542,6247,787334,359223,323585,363215,210211,805307,479438,435219,827937,933233,549458,641882,512918,327639,146911,435566,70165,287626,567303,41469,729153,957888,334792,237226,656367,739806,903170,254125,1034077,609579,751495,641403,135504,773638,745740,918614,765965,924505,728152,1001754,626396,972643,141747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]