SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567221 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567221 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714911,971480,625342,354977,190775,367889,55774,993928,1028223,936922,662590,345143,281624,500542,908513,382375,77568,83304,1028046,769347,141030,414096,970879,608708,735576,416026,608707,198649,659010,815476,1026028,31415,857737,302952,746062,634199,1023501,88876,833863,126002,1019329,973583,652848,570514,936620,316144,371955,476109,357785,1043440,960178,346645,110411,650882,569132,899563,212112,831520,620709,434297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]