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` = 281258 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281258 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230133,369963,192640,871855,13452,69674,395356,357961,126050,110903,186664,6754,191463,1008258,287393,265030,504219,109431,744454,231220,497581,720363,343306,581087,526435,89122,534089,139321,548752,436410,622324,753760,548356,388478,27081,332733,796755,146137,736923,83686,713878,593435,539596,461373,573168,297829,932102,102252,554937,898900,45240,889774,769280,801487,885829,184121,606204,469989,48563,1041917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001678s ]