SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564253 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564253 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78486,443171,938032,526858,520836,997433,558160,170937,512386,62303,668722,259628,297397,447214,838122,903774,661882,416564,66270,396561,180218,8034,1038290,55799,661788,404742,750000,365233,478265,648427,209964,470686,594934,658288,627490,305621,283580,378493,690190,486538,614339,255619,596575,500125,887921,129983,1048254,206741,189061,907090,136284,843903,28081,179940,518840,459936,961656,416027,50334,265140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]