SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025232 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025232 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163878,1013101,140833,905756,670641,15905,945472,1029791,859478,116171,382744,790564,558223,751952,8997,789935,567222,477573,9336,332327,848821,876605,193199,225926,363303,800447,505113,158011,814842,923306,635340,850171,538823,447038,705070,953621,148717,319396,254084,811840,198009,86703,59405,844436,886763,827933,530850,242858,359745,405663,779755,752355,173370,132239,68436,1048627,861832,990984,312052,170530) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025232 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025232 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]