SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455311 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455311 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76048,502108,676671,898259,306932,989488,175796,122037,760608,72216,221412,98551,857357,487866,361862,696949,770142,711683,39395,655341,128435,920949,81960,984999,197925,876329,380555,531456,852139,926015,959705,723173,163157,341806,721812,178412,417802,1043782,876322,256175,856611,917977,61333,541582,15300,955642,140247,236545,283749,776152,777083,604206,715953,481687,5401,750527,793074,946802,177812,857249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]