SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499613 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499613 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88463,398165,226486,573551,164510,529540,428357,715175,1018324,618510,117597,838687,544365,820922,1011869,192176,215696,644341,473514,1042773,1020180,584237,457790,850464,885471,551562,639069,27758,161593,999380,163592,847793,139683,224253,736578,694851,433892,668626,599582,271820,374831,971972,102167,323938,247213,150324,913743,763000,188126,966010,1009557,693195,602991,617499,106795,23073,522312,829027,284573,481438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]