SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415102 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415102 [ RunTime:0.004335s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888001,409976,681082,345284,393724,733057,470754,142341,558087,852649,279842,1013949,764914,546222,226545,656532,795662,852310,750770,59385,628684,744272,125578,519172,79100,987766,104617,403036,900245,153353,467373,728870,3264,227456,954436,938357,528901,168585,495360,317720,761454,110812,90735,389849,214489,75115,851633,41842,939708,936929,668482,467736,651091,975252,278140,554844,149593,1042435,303365,1003748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001078s ]