SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589807 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589807 [ RunTime:0.001404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120830,1034226,277658,1034367,440577,334722,271762,184238,701075,379479,135191,601773,80532,625294,133132,909310,815061,66159,128139,400010,607421,464556,666756,279870,459270,909468,645633,561695,356306,419308,33721,776448,381252,677637,832699,368746,121369,864656,802517,36651,965365,863957,659256,349042,285651,960564,491799,835969,925866,753241,67297,746653,910238,339179,377647,796586,944999,521955,440887,643801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]