SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038740 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038740 [ RunTime:0.002543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590695,711001,374129,185,922968,303189,854892,518341,323442,402060,793675,824905,326805,661111,503756,171469,143104,882283,629207,51715,751120,278716,893706,467293,43944,572548,555081,132615,1010942,384141,325915,827400,22505,32552,986489,782967,1024699,905699,552199,831574,169528,148846,221671,912240,546139,238233,391972,540369,285246,772359,899961,173355,210426,464583,102034,599124,286916,803337,695366,237077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]