SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502596 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502596 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858402,99649,375058,531090,341313,163913,640109,925273,958383,309511,425455,825495,303745,970393,763574,311700,781825,874157,406774,58827,421450,46479,978081,950084,431832,631581,323867,905095,461518,178109,299968,818299,979636,673520,726488,408937,58521,802124,307778,682848,950488,293149,561225,691913,738554,308821,335353,165404,841655,229088,918756,811358,301019,274686,357158,822690,30308,74142,127746,843892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]