SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557266 LIMIT 1 [ RunTime:0.000527s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557266 [ RunTime:0.003776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981011,305628,940309,659788,114700,410417,314848,1030611,711014,67396,572578,1007178,180748,454826,470638,507067,788256,178316,317758,493415,1867,346705,648953,847580,566020,64810,931610,371103,652831,183661,819588,653206,850152,784364,682143,256281,577400,1029865,637459,157423,279097,33774,696037,312258,209120,415262,72138,236564,721222,121046,628093,710157,1024306,227624,1008983,449232,653749,487746,97402,71110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]