SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514914 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514914 [ RunTime:0.002370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776115,344778,797996,205147,1048142,459124,774238,1016960,96551,238376,891719,1017381,55112,385880,887424,86738,1043760,741209,408313,740969,917836,254933,715271,791742,222804,959265,907764,483035,862271,783268,884235,192259,636038,112273,1047013,19441,185864,194967,462865,768746,378732,538502,67695,279595,942030,801170,472175,111910,363799,108521,900437,60032,409525,506117,570603,710465,750769,875058,912578,140990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]