SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557911 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557911 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525582,417088,243797,341370,725360,260321,985587,43956,949893,574556,928592,266404,443901,540751,762604,199045,608227,871110,888695,174691,266428,941466,751119,409943,289212,49947,503773,20957,2441,625871,970428,509657,407647,397659,523111,720084,1042271,229433,575007,975130,561032,704401,369318,362331,593191,430145,1197,87585,505789,517622,162826,142619,427944,655198,383751,612624,989718,516327,947638,791319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]