SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031713 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031713 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502609,666750,616538,811437,850294,318961,743260,193509,560362,147303,876508,401977,479688,741823,431051,958578,67394,25713,175456,92442,179907,612874,969022,30414,1043623,67472,438754,943466,888722,9977,827235,703281,315225,965184,789335,96058,910946,146764,1021781,746689,410935,1014799,411606,685625,773777,965591,137512,1017601,837200,958203,962792,341340,29735,966678,58678,199472,905445,621994,797660,741579) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]