SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042215 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042215 [ RunTime:0.002209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791832,1031934,90176,75199,452338,1039289,916736,298748,398374,1009579,781023,712734,773331,218214,364551,645406,399430,157054,44346,1011753,709874,272205,315810,1018016,88281,899769,349605,526843,237381,698999,806036,402721,401740,418524,877160,637827,1007701,749347,912055,262631,241431,172765,432321,934159,680456,468670,914193,743876,567302,683256,896558,41473,158501,334673,592351,717399,471688,1038988,918044,434755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]