SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417142 LIMIT 1 [ RunTime:0.001704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417142 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681626,126988,812032,535861,734133,41080,822712,774914,258448,612925,327280,489024,359569,531644,445593,796680,669370,349848,619136,817195,771492,800492,86402,790560,571377,366307,719822,887671,959114,4235,636361,85040,135931,929899,666800,862152,105282,927783,327767,333697,585115,1033757,660891,3717,289791,929796,481664,661868,544928,665143,157207,783359,6888,178074,880024,243963,906569,243388,1042485,802695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417142 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417142 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001280s ]