SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398169 LIMIT 1 [ RunTime:0.002432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398169 [ RunTime:0.002461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399394,466764,79856,346838,543491,199452,370105,624203,31037,36452,844612,623663,561499,166282,528466,560211,613964,982135,284777,656526,717852,572937,9182,562773,754047,937664,187995,911349,685352,148291,746921,119526,471358,26811,515597,493903,1011546,14551,274636,683301,651053,246366,668780,382969,653801,589522,584283,171261,465857,70775,393461,381234,834145,312672,501190,259504,1003900,130599,341880,405249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001894s ]