SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513631 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513631 [ RunTime:0.002678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211072,688799,538544,757199,917712,108911,353841,527059,64628,663197,1007569,866893,82281,568420,631596,105101,312549,900802,35481,386824,678436,371471,684252,138403,593965,468739,407575,86493,597918,811091,1040671,323026,341768,753647,988887,601644,356212,549529,841458,276293,165601,68681,500888,123922,964016,800566,64493,516770,648146,649648,888398,3373,134268,881318,887399,155750,288942,943152,833909,642394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]