SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289918 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289918 [ RunTime:0.002514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985510,91765,854727,513601,744542,170452,648586,863872,162095,641540,943792,569507,94278,598345,482660,207051,188369,567318,42508,739789,499655,282077,173394,697884,493865,802812,380115,328266,141759,907109,60884,800096,117171,212912,301926,360203,628060,624770,722011,495534,109185,509831,326650,284472,740718,1029002,698689,481195,444553,59734,239152,352648,123167,331211,404165,1042704,436679,227112,530470,128423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001475s ]