SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401957 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401957 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (744135,178991,64562,438485,378169,1042112,580790,840443,563695,538986,628159,886798,258392,951750,212906,37181,168041,461718,273425,503386,11759,175211,688580,923421,304879,733675,125401,472496,617057,931429,790592,237454,449799,786719,1036424,532268,281705,915921,362522,521713,465308,998831,264840,530882,672113,936388,715527,244298,189013,737229,407018,285600,55184,871512,320562,610490,748993,1035647,575481,223144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]