SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410534 LIMIT 1 [ RunTime:0.000758s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410534 [ RunTime:0.002888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017677,991799,3322,683115,414913,215298,884925,636288,1008624,321988,624184,51262,773975,457619,271677,998154,632589,566719,463178,1006736,1005550,598394,396682,388339,241936,438883,949793,239091,352100,41057,738593,843828,116100,756930,268082,807622,953712,314892,757969,780459,257565,522622,217319,192499,1037155,730627,453741,672512,1034475,214477,806906,383893,382140,832291,817402,78547,762383,303322,166566,683823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]