SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584445 LIMIT 1 [ RunTime:0.000675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584445 [ RunTime:0.002149s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426769,108193,297946,572118,815945,196208,723295,108424,476404,157246,263759,183642,160499,129796,252328,828188,262286,787681,679412,18340,264212,1042484,1004789,247571,116429,332384,116330,437337,752045,734667,52192,984126,746827,903713,602862,369701,331640,501650,62367,462902,537013,48123,974508,278817,749895,828115,307788,11297,659813,79835,227402,826452,971734,331507,554977,333225,710430,6135,608055,203505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]