SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561704 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561704 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027854,28391,574936,20787,182170,797696,1031907,538536,344616,295153,311451,273096,722716,326392,482237,84718,1023643,255232,351125,389816,372009,830141,521343,472387,876488,140956,868908,231673,307810,521599,497931,931698,801104,776398,108291,838141,197721,1002474,24819,99194,566560,365789,509659,251116,224416,8987,125425,434364,413609,439080,497891,460293,493958,231487,79371,662451,1016006,914365,882138,675071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]