SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515603 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515603 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850437,999730,337028,594201,954617,149737,323706,551335,1017308,734509,544962,62015,39458,654679,126274,956266,792752,980267,273798,755333,892674,983148,626927,833719,1034796,508946,734423,744037,106325,509093,181152,466439,717254,122714,556537,640649,671412,735623,52650,134896,379117,929280,882018,612124,493492,191733,138915,105528,126255,287730,257833,831890,482515,567252,343669,386379,1025071,112409,640302,786563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]