SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975804 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975804 [ RunTime:0.002487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011940,946035,722691,631725,826246,118428,415070,239291,716063,401599,762956,122839,842759,794066,786907,248661,692205,480652,432567,355760,408759,50766,913763,1002455,240429,145549,643646,990782,675449,953635,523961,165833,144668,679338,980548,173194,829494,199549,932241,705411,349596,800420,775772,550652,844980,408942,805865,764414,878941,584519,732399,430782,436543,617686,660567,4640,6608,447361,241224,839742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000853s ]