SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547313 LIMIT 1 [ RunTime:0.001607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547313 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757803,946068,478886,250345,20738,946463,473742,118856,53232,546017,987647,489582,1013562,437648,342063,167565,308355,920818,375083,118385,419328,606123,524242,929567,482554,285554,704760,455279,176593,473498,450596,698736,891882,860070,390230,108834,76735,834240,222496,630774,789075,464179,670673,721532,116979,863596,171683,598689,375725,829241,414907,262000,260849,417885,813836,410525,102204,702373,919748,827697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]