SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411571 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411571 [ RunTime:0.003231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380452,698886,16442,878396,538406,25689,681027,792899,850050,876967,374611,730834,1017187,1029587,456352,97619,319912,763593,888606,999563,163360,571823,84151,64497,462032,29452,180972,945006,353125,127806,67279,743205,585080,12654,981806,51553,320513,21843,620511,609925,825848,134704,997476,183208,957791,853966,955029,658899,938980,517083,1042974,728196,180048,886758,476931,185919,183587,160327,193937,28014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]