SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402540 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402540 [ RunTime:0.004163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382690,976065,596919,52163,501600,373711,839738,111373,1047036,715164,902014,928847,479892,960449,1029680,598491,464264,529045,400515,418380,837456,402695,1001047,932050,103691,598267,463525,869644,662131,314948,209731,649126,379098,622616,261125,1044579,594993,963431,832856,908805,786491,711613,658980,181993,469054,574122,970208,757731,853075,260265,906525,1041668,21386,311163,432575,526645,893069,594495,936138,667479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]