SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111192 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111192 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246773,911046,558433,719316,229102,276659,910176,277171,731410,369263,636575,507227,1010424,200341,76700,701398,707413,309625,84079,82267,129162,49160,396199,954440,601723,368699,891754,311028,77403,248764,163937,54339,820149,564443,712096,89343,129926,690662,498490,817631,20741,762837,599472,405226,599543,558186,422729,222144,550446,467455,906021,411778,260013,1020709,616204,602937,874387,920086,804288,625666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111192 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111192 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]