SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502108 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502108 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424821,595139,34520,998846,21130,128764,334747,137489,72159,495407,453778,1009771,812654,352504,421601,746757,532404,772159,779939,394112,897978,970305,360758,143702,452027,194569,1008085,377705,1031139,639239,532696,642026,862145,854466,313602,742231,706281,436553,821213,942663,901490,162445,773373,416563,201404,202880,876210,719767,1038884,599422,730716,692654,715832,734687,87871,953276,984643,266081,504164,1027203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]