SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333631 LIMIT 1 [ RunTime:0.001164s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333631 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (494984,684949,132949,51022,373590,516966,1018185,944107,767063,222578,795544,774531,144390,500027,75644,304583,32908,580563,300409,607954,860811,614239,122503,539081,278789,242042,100984,506301,311263,812604,91760,397700,564614,345516,404530,762508,1000257,89632,700032,596448,49695,900622,1004852,768771,895131,797285,850702,69143,50741,311490,847664,949028,249616,582838,642101,85814,55317,541081,878672,583184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]