SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487933 LIMIT 1 [ RunTime:0.000667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487933 [ RunTime:0.003422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435124,916123,1023963,411165,383358,464194,769579,1017123,566830,803963,993462,553131,817534,187876,216858,906110,679693,959913,679353,805833,965355,348017,498723,599735,423631,338317,37161,67507,605647,294647,500023,771364,325893,42975,413775,12943,946333,798594,916912,147977,178756,953689,817014,239361,522734,876370,601705,1034130,1047312,225224,612076,421330,1034825,805000,768557,323802,995439,138793,468109,725843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]